This is a step by step log to combine survey results for the Southwark audit study
| Name | Description | URL (path) |
|---|---|---|
| feb_2021 oct18_N | edited spreadsheet from CASS survey | https://docs.google.com/spreadsheets/d/1WfDi7ojsyP_6uL2ts62kyQAxiwj4Xe9F/edit#gid=881012 |
| oct18_N | CASS survey results geopackages | https://drive.google.com/file/d/1VV5nxWja2sA5jbKpHIgdVsE2Ie393QYH/view?usp=sharing |
| 200601 New Polygons final upload | New polygons (5 folders) | https://drive.google.com/drive/folders/1dVyhXth5rYxvod10N16tDeF_Qvo5I8fz?usp=sharing |
| REDACTED_164_OKR Survey_WMT 2019 business base_191104 | OKR survey (spreadsheet with point data) | ~/Documents/SINDA_local/data_from_southwark/WMT OKR Business Survey 2019/REDACTED_164_OKR Survey_WMT 2019 business base_191104.xlsx |
feb2021 <- read_xlsx("feb_2021 oct18_N.xlsx")
oct18 <- st_read("/Users/nicolas/Documents/R_GitHub/sind/oct18_N.gpkg")
## Reading layer `masterGJ' from data source `/Users/nicolas/Documents/R_GitHub/sind/oct18_N.gpkg' using driver `GPKG'
## Simple feature collection with 2515 features and 100 fields (with 458 geometries empty)
## geometry type: MULTIPOLYGON
## dimension: XY
## bbox: xmin: 531305.5 ymin: 171277 xmax: 536322.5 ymax: 180434.8
## projected CRS: unnamed
dir3
## [1] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/56_90150002_b.gpkg"
## [2] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/46_15700001_b.gpkg"
## [3] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200015_b.gpkg"
## [4] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_200001_b.gpkg"
## [5] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200014_b.gpkg"
## [6] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/627_62400064_b.gpkg"
## [7] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/6_870_b.gpkg"
## [8] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200017_b.gpkg"
## [9] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/63_90320001_b.gpkg"
## [10] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/34_844_b.gpkg"
## [11] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/65_90320002_b.gpkg"
## [12] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/56_9015002_b.gpkg"
## [13] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/50_9080002_b.gpkg"
## [14] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/96_901780002_b.gpkg"
## [15] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/61_879_b.gpkg"
## [16] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200004_b.gpkg"
## [17] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/58_90120002_b.gpkg"
## [18] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/47_901570001_b.gpkg"
## [19] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/50_9080003_b.gpkg"
## [20] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200005_b.gpkg"
## [21] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/623_9030001_b.gpkg"
## [22] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/11_9040001_b.gpkg"
## [23] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/34_842_b.gpkg"
## [24] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/95_901780001_b.gpkg"
## [25] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/34_50001_b.gpkg"
## [26] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200016_b.gpkg"
## [27] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/47_1570001_b.gpkg"
## [28] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200008_b.gpkg"
## [29] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_200002_b.gpkg"
## [30] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200011_b.gpkg"
## [31] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400037_b.gpkg"
## [32] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200013_b.gpkg"
## [33] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400032_b.gpkg"
## [34] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400046_b.gpkg"
## [35] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400033_b.gpkg"
## [36] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400039_b.gpkg"
## [37] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400044_b.gpkg"
## [38] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400035_b.gpkg"
## [39] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400029_b.gpkg"
## [40] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400042_b.gpkg"
## [41] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400045_b.gpkg"
## [42] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400030_b.gpkg"
## [43] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400041_b.gpkg"
## [44] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400038_b.gpkg"
## [45] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400031_b.gpkg"
## [46] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400043_b.gpkg"
## [47] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400040_b.gpkg"
## [48] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400034_b.gpkg"
## [49] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400024_b.gpkg"
## [50] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400028_b.gpkg"
## [51] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400027_b.gpkg"
## [52] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400036_b.gpkg"
## [53] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400023_b.gpkg"
## [54] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400025_b.gpkg"
## [55] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400026_b.gpkg"
## [56] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200009_b.gpkg"
## [57] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200012_b.gpkg"
## [58] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200003_b.gpkg"
## [59] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200010_b.gpkg"
## [60] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200006_b.gpkg"
## [61] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/50_9080001_b.gpkg"
## [62] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200018_b.gpkg"
## [63] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/56_90120001_b.gpkg"
## [64] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200007_b.gpkg"
## [65] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/96_901780003_b.gpkg"
## [66] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/345_90790002_b.gpkg"
## [67] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/129_1021_b.gpkg"
## [68] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790016_b.gpkg"
## [69] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060014_b.gpkg"
## [70] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060004_b.gpkg"
## [71] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/36_9050002_b.gpkg"
## [72] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060013_b.gpkg"
## [73] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060015_b.gpkg"
## [74] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400035_b.gpkg"
## [75] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400047_b.gpkg"
## [76] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/278_7900001_b.gpkg"
## [77] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060007_b.gpkg"
## [78] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/123_90210001_b.gpkg"
## [79] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640001_b.gpkg"
## [80] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640007_b.gpkg"
## [81] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400015_b.gpkg"
## [82] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640003_b.gpkg"
## [83] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790013_b.gpkg"
## [84] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400024_b.gpkg"
## [85] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060012_b.gpkg"
## [86] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400026_b.gpkg"
## [87] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400048_b.gpkg"
## [88] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400045_b.gpkg"
## [89] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400027_b.gpkg"
## [90] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400034_b.gpkg"
## [91] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400011_b.gpkg"
## [92] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400010_b.gpkg"
## [93] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400046_b.gpkg"
## [94] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400028_b.gpkg"
## [95] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400043_b.gpkg"
## [96] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400032_b.gpkg"
## [97] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400023_b.gpkg"
## [98] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400019_b.gpkg"
## [99] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400042_b.gpkg"
## [100] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640008_b.gpkg"
## [101] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400019_b.gpkg"
## [102] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400031_b.gpkg"
## [103] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400018_b.gpkg"
## [104] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400022_b.gpkg"
## [105] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400020_b.gpkg"
## [106] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400021_b.gpkg"
## [107] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400041_b.gpkg"
## [108] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400013_b.gpkg"
## [109] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040009_b.gpkg"
## [110] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400016_b.gpkg"
## [111] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400017_b.gpkg"
## [112] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400018_b.gpkg"
## [113] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400015_b.gpkg"
## [114] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400014_b.gpkg"
## [115] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400011_b.gpkg"
## [116] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400010_b.gpkg"
## [117] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/40_9060001_b.gpkg"
## [118] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400012_b.gpkg"
## [119] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040006_b.gpkg"
## [120] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790010_b.gpkg"
## [121] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/282_7900005_b.gpkg"
## [122] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040005_b.gpkg"
## [123] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060002_b.gpkg"
## [124] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060008_b.gpkg"
## [125] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040007_b.gpkg"
## [126] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040008_b.gpkg"
## [127] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040004_b.gpkg"
## [128] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060010_b.gpkg"
## [129] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/35_9050001_b.gpkg"
## [130] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790009_b.gpkg"
## [131] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/443_1861_b.gpkg"
## [132] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/443_1855_b.gpkg"
## [133] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790014_b.gpkg"
## [134] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300058_b.gpkg"
## [135] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790006_b.gpkg"
## [136] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300057_b.gpkg"
## [137] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790008_b.gpkg"
## [138] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790015_b.gpkg"
## [139] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790011_b.gpkg"
## [140] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300056_b.gpkg"
## [141] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/280_7900003_b.gpkg"
## [142] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790017_b.gpkg"
## [143] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300055_b.gpkg"
## [144] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640005_b.gpkg"
## [145] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400036_b.gpkg"
## [146] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060006_b.gpkg"
## [147] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400025_b.gpkg"
## [148] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790012_b.gpkg"
## [149] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/281_7900004_b.gpkg"
## [150] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640006_b.gpkg"
## [151] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400012_b.gpkg"
## [152] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400017_b.gpkg"
## [153] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060003_b.gpkg"
## [154] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400040_b.gpkg"
## [155] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060011_b.gpkg"
## [156] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640002_b.gpkg"
## [157] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400021_b.gpkg"
## [158] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400030_b.gpkg"
## [159] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640009_b.gpkg"
## [160] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300053_b.gpkg"
## [161] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400016_b.gpkg"
## [162] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300054_b.gpkg"
## [163] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400020_b.gpkg"
## [164] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400039_b.gpkg"
## [165] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300052_b.gpkg"
## [166] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400038_b.gpkg"
## [167] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640004_b.gpkg"
## [168] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300048_b.gpkg"
## [169] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300050_b.gpkg"
## [170] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300046_b.gpkg"
## [171] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400033_b.gpkg"
## [172] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300051_b.gpkg"
## [173] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300045_b.gpkg"
## [174] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300047_b.gpkg"
## [175] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300049_b.gpkg"
## [176] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400037_b.gpkg"
## [177] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300039_b.gpkg"
## [178] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300042_b.gpkg"
## [179] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300043_b.gpkg"
## [180] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300044_b.gpkg"
## [181] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300041_b.gpkg"
## [182] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300036_b.gpkg"
## [183] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300040_b.gpkg"
## [184] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300033_b.gpkg"
## [185] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300034_b.gpkg"
## [186] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300037_b.gpkg"
## [187] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300038_b.gpkg"
## [188] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300035_b.gpkg"
## [189] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300032_b.gpkg"
## [190] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300030_b.gpkg"
## [191] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300031_b.gpkg"
## [192] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/786_1861_b.gpkg"
## [193] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150009_b.gpkg"
## [194] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/810_1855_b.gpkg"
## [195] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/829_314_b.gpkg"
## [196] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150010_b.gpkg"
## [197] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/345_90790001_b.gpkg"
## [198] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300027_b.gpkg"
## [199] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300028_b.gpkg"
## [200] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300029_b.gpkg"
## [201] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060016_b.gpkg"
## [202] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/120_901001_b.gpkg"
## [203] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300026_b.gpkg"
## [204] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/279_7900002_b.gpkg"
## [205] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300023_b.gpkg"
## [206] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300024_b.gpkg"
## [207] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/113_90200019_b.gpkg"
## [208] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150007_b.gpkg"
## [209] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060005_b.gpkg"
## [210] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300020_b.gpkg"
## [211] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060009_b.gpkg"
## [212] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300021_b.gpkg"
## [213] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150008_b.gpkg"
## [214] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600004_b.gpkg"
## [215] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300022_b.gpkg"
## [216] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600006_b.gpkg"
## [217] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600005_b.gpkg"
## [218] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/572_90230008_b.gpkg"
## [219] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/200_619_b.gpkg"
## [220] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/571_90510001_b.gpkg"
## [221] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/570_90400001_b.gpkg"
## [222] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300018_b.gpkg"
## [223] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300017_b.gpkg"
## [224] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300016_b.gpkg"
## [225] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/569_90250025_b.gpkg"
## [226] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300019_b.gpkg"
## [227] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790005_b.gpkg"
## [228] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/345_90790003_b.gpkg"
## [229] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300015_b.gpkg"
## [230] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/345_90790004_b.gpkg"
## [231] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300014_b.gpkg"
## [232] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300012_b.gpkg"
## [233] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300013_b.gpkg"
## [234] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300011_b.gpkg"
## [235] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300010_b.gpkg"
## [236] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030008_b.gpkg"
## [237] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030009_b.gpkg"
## [238] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300025_b.gpkg"
## [239] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030007_b.gpkg"
## [240] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030005_b.gpkg"
## [241] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030003_b.gpkg"
## [242] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030006_b.gpkg"
## [243] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030004_b.gpkg"
## [244] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030002_b.gpkg"
## [245] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_1030001_b.gpkg"
## [246] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/450_10500001_b.gpkg"
## [247] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/565_901370001_b.gpkg"
## [248] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/560_902390001_b.gpkg"
## [249] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/702_982_b.gpkg"
## [250] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/558_90540001_b.gpkg"
## [251] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/703_966_b.gpkg"
## [252] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/704_950_b.gpkg"
## [253] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/701_984_b.gpkg"
## [254] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/700_989_b.gpkg"
## [255] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/449_1050002_b.gpkg"
## [256] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/443_1849_b.gpkg"
## [257] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/441_1844_b.gpkg"
## [258] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150006_b.gpkg"
## [259] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/442_1846_b.gpkg"
## [260] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/465_901280001_b.gpkg"
## [261] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/440_1840_b.gpkg"
## [262] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150005_b.gpkg"
## [263] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/461_901240001_b.gpkg"
## [264] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150003_b.gpkg"
## [265] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/459_901230001_b.gpkg"
## [266] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/794_352_b.gpkg"
## [267] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/698_1055_b.gpkg"
## [268] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/456_901220001_b.gpkg"
## [269] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/458_901230002_b.gpkg"
## [270] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/699_992_b.gpkg"
## [271] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/997_994_b.gpkg"
## [272] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/696_997_b.gpkg"
## [273] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/694_938_b.gpkg"
## [274] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/696_2600001_b.gpkg"
## [275] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/695_2600002_b.gpkg"
## [276] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/693_920_b.gpkg"
## [277] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/448_901050001_b.gpkg"
## [278] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150002_b.gpkg"
## [279] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/813_344_b.gpkg"
## [280] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/692_925_b.gpkg"
## [281] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/730_357_b.gpkg"
## [282] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/438_901040003_b.gpkg"
## [283] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/437_901040002_b.gpkg"
## [284] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/436_901040001_b.gpkg"
## [285] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/715_339_b.gpkg"
## [286] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/327_90670001_b.gpkg"
## [287] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150004_b.gpkg"
## [288] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_307_b.gpkg"
## [289] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600008_b.gpkg"
## [290] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600007_b.gpkg"
## [291] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/692_913_b.gpkg"
## [292] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/691_2700001_b.gpkg"
## [293] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/556_90830001_b.gpkg"
## [294] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/554_901040004_b.gpkg"
## [295] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/690_1030002_b.gpkg"
## [296] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/551_901050004_b.gpkg"
## [297] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/555_90840001_b.gpkg"
## [298] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/549_901050003_b.gpkg"
## [299] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/432_901030001_b.gpkg"
## [300] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/532_9100002_b.gpkg"
## [301] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/361_90850001_b.gpkg"
## [302] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/460_1888_b.gpkg"
## [303] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/547_901250002_b.gpkg"
## [304] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/548_901240001_b.gpkg"
## [305] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/547_901250001_b.gpkg"
## [306] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/89_90890001_b.gpkg"
## [307] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/539_90290001_b.gpkg"
## [308] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/538_902400002_b.gpkg"
## [309] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/457_1879_b.gpkg"
## [310] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/439_1810_b.gpkg"
## [311] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/537_902400001_b.gpkg"
## [312] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/355_1577_b.gpkg"
## [313] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/370_9100001_b.gpkg"
## [314] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/353_1562_b.gpkg"
## [315] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/354_1566_b.gpkg"
## [316] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/536_901110001_b.gpkg"
## [317] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/534_902530001_b.gpkg"
## [318] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/533_901970001_b.gpkg"
## [319] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/535_902530002_b.gpkg"
## [320] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/478_901650002_b.gpkg"
## [321] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/477_901650001_b.gpkg"
## [322] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/545_901490001_b.gpkg"
## [323] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/284_7900007_b.gpkg"
## [324] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/285_7900008_b.gpkg"
## [325] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/286_7900009_b.gpkg"
## [326] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/577_901150001_b.gpkg"
## [327] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/425_96900001_b.gpkg"
## [328] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/587_90470006_b.gpkg"
## [329] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/578_90960001_b.gpkg"
## [330] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/283_7900006_b.gpkg"
## [331] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/601_90610003_b.gpkg"
## [332] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/589_90940006_b.gpkg"
## [333] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/689_90790021_b.gpkg"
## [334] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/607_90780001_b.gpkg"
## [335] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/611_90450007_b.gpkg"
## [336] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/608_902340001_b.gpkg"
## [337] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/590_90940005_b.gpkg"
## [338] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/687_90610002_b.gpkg"
## [339] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/606_90610002_b.gpkg"
## [340] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/598_90470004_b.gpkg"
## [341] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/603_902930001_b.gpkg"
## [342] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/655_90460003_b.gpkg"
## [343] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/613_901840001_b.gpkg"
## [344] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/662_90150003_b.gpkg"
## [345] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/653_90450001_b.gpkg"
## [346] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/621_90320004_b.gpkg"
## [347] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/666_90130001_b.gpkg"
## [348] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/7_9030002_b.gpkg"
## [349] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/668_90730001_b.gpkg"
## [350] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/657_901670001_b.gpkg"
## [351] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/663_901480001_b.gpkg"
## [352] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/659_901580001_b.gpkg"
## [353] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/617_90160005_b.gpkg"
## [354] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/581_90480002_b.gpkg"
## [355] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/686_901610001_b.gpkg"
## [356] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/52_9080001_b.gpkg"
## [357] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/687_90450002_b.gpkg"
## [358] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/76_951_b.gpkg"
## [359] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/619_90440001_b.gpkg"
## [360] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/61_872_b.gpkg"
## [361] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/674_90040001_b.gpkg"
## [362] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/686_901660001_b.gpkg"
## [363] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/31_9050003_b.gpkg"
## [364] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/665_90470001_b.gpkg"
## [365] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/616_90450006_b.gpkg"
## [366] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/688_90450003_b.gpkg"
## [367] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/686_90450004_b.gpkg"
## [368] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/591_90940004_b.gpkg"
## [369] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/690_90940001_b.gpkg"
## [370] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/602_90460004_b.gpkg"
## [371] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/588_90940003_b.gpkg"
## [372] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/594_90470005_b.gpkg"
## [373] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/592_90940002_b.gpkg"
## [374] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/618_90450005_b.gpkg"
## [375] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/671_90610001_b.gpkg"
## [376] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/687_1590_b.gpkg"
## [377] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/89_90170002_B.gpkg"
## [378] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/209_90420003_B.gpkg"
## [379] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/80_90160001_B.gpkg"
## [380] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250014_B.gpkg"
## [381] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/190_90320001_B.gpkg"
## [382] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/240_90460002_B.gpkg"
## [383] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/245_90470001_B.gpkg"
## [384] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/260_6000002_B.gpkg"
## [385] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/273_6100010_B.gpkg"
## [386] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/271_6100008_B.gpkg"
## [387] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/259_6000001_B.gpkg"
## [388] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230006_B.gpkg"
## [389] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/275_6100012_B.gpkg"
## [390] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230004_B.gpkg"
## [391] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/263_6000005_B.gpkg"
## [392] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250008_B.gpkg"
## [393] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250019_B.gpkg"
## [394] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/195_90330001_B.gpkg"
## [395] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/246_90470002_B.gpkg"
## [396] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250010_B.gpkg"
## [397] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250024_B.gpkg"
## [398] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/87_90160004_B.gpkg"
## [399] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250005_B.gpkg"
## [400] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/269_6100006_B.gpkg"
## [401] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/261_6000003_B.gpkg"
## [402] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/196_90360001_B.gpkg"
## [403] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250018_B.gpkg"
## [404] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230002_B.gpkg"
## [405] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/88_90170001_B.gpkg"
## [406] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250004_B.gpkg"
## [407] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/149_90230003_B.gpkg"
## [408] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/239_90460001_B.gpkg"
## [409] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/211_90420004_B.gpkg"
## [410] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/265_6100002_B.gpkg"
## [411] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/210_90420002_B.gpkg"
## [412] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250022_B.gpkg"
## [413] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/181_90300001_B.gpkg"
## [414] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/270_6100007_B.gpkg"
## [415] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250007_B.gpkg"
## [416] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250023_B.gpkg"
## [417] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/201_3900001_B.gpkg"
## [418] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/81_90160002_B.gpkg"
## [419] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/252_90550001_B.gpkg"
## [420] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230001_B.gpkg"
## [421] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/77_90150001_B.gpkg"
## [422] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/268_6100005_B.gpkg"
## [423] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/266_6100003_B.gpkg"
## [424] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/267_6100004_B.gpkg"
## [425] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/276_6100013_B.gpkg"
## [426] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250009_B.gpkg"
## [427] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/149_90230001_B.gpkg"
## [428] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230005_B.gpkg"
## [429] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230003_B.gpkg"
## [430] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/274_6100011_B.gpkg"
## [431] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/262_6000004_B.gpkg"
## [432] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/272_6100009_B.gpkg"
## [433] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230007_B.gpkg"
## [434] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250016_B.gpkg"
## [435] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/214_90420005_B.gpkg"
## [436] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/86_90160003_B.gpkg"
## [437] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250011_B.gpkg"
## [438] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/277_6100014_B.gpkg"
## [439] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250021_B.gpkg"
## [440] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250003_B.gpkg"
## [441] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/197_90360002_B.gpkg"
## [442] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/248_90480001_B.gpkg"
## [443] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250020_B.gpkg"
## [444] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250012_B.gpkg"
## [445] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/247_90470003_B.gpkg"
## [446] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250001_B.gpkg"
## [447] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250013_B.gpkg"
## [448] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250017_B.gpkg"
## [449] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250006_B.gpkg"
## [450] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/208_90420001_B.gpkg"
## [451] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250002_B.gpkg"
## [452] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250015_B.gpkg"
## [453] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/264_6100001_B.gpkg"
#grep("90220001", dir3)
#sapply(gpkg, function(y) "90220001" %in% y)
# remove lists with nrow > 0
gpkg1 <- gpkg[sapply(gpkg, nrow) > 0]
#unlist(gpkg1, recursive = F)
# create a new variable with CRS
gpkg2 <- lapply(gpkg1, function(x) within(x, crs <- unlist(st_crs(x), recursive = F)))
# select BNG
gpkg21 <- rbindlist(gpkg2, use.names=FALSE) %>%
filter(crs == "OSGB 1936 / British National Grid") %>%
st_sf() %>%
select(fid)
# select WGS 84
gpkg22 <- rbindlist(gpkg2, use.names=FALSE) %>%
filter(crs == "WGS 84") %>%
st_sf() %>%
st_set_crs(value = 4326) %>% # assign original projection
st_transform(27700) %>% # transform to join all
select(fid)
## Warning: st_crs<- : replacing crs does not reproject data; use st_transform for
## that
# select != BNG | != 4326
gpkg23 <- rbindlist(gpkg2, use.names=FALSE) %>%
filter(crs != "OSGB 1936 / British National Grid") %>%
filter(crs != "WGS 84") %>%
st_sf() %>%
select(fid)
pol <- gpkg21 %>%
rbind(gpkg22)
pol <- pol %>%
rbind(gpkg23)
okr <- read_excel("~/Documents/SINDA_local/data_from_southwark/WMT OKR Business Survey 2019/REDACTED_164_OKR Survey_WMT 2019 business base_191104.xlsx",
col_types = c("text", "numeric", "text",
"text", "text", "text", "text", "numeric",
"text", "text", "text", "text", "text",
"text", "text", "text", "text", "text",
"text", "text", "text", "text", "text",
"text", "text", "numeric", "numeric",
"numeric", "numeric", "text", "text",
"text", "text", "text", "text", "text",
"text", "numeric", "text", "numeric",
"text", "text", "text", "numeric",
"numeric", "numeric", "numeric"))
glimpse(feb2021)
## Rows: 2,548
## Columns: 87
## $ query_code <dbl> 346, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ `1_Surveyor_Nickname` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "N…
## $ `2_Map_sheet_number` <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 13…
## $ `3_Functional_Unit_Co` <dbl> 90790005, 90790002, 90790003, 90790004, 90…
## $ `5_11_Name_of_organis` <chr> "(unknown)", "(unknown)", "(unknown)", "(u…
## $ `6_12_Description_of_` <chr> "(food production / storage)", "(food prod…
## $ `7_13_When_was_the_or` <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `8_14_Do_you_regard_t` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `9_15_If_no_what_type` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `10_16_If_other_pleas` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `12_21_Total_number_o` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `13_22_Observed_or_Ve` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `14_23_How_many_FTEs_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `15_24_Observed_or_Ve` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `16_25_Is_the_organis` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `17_26_How_many_peopl` <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `19_31_Floor_levels_t` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `20_32_How_many_store` <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `21_33_Unit_size_Inse` <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `22_34_Square_metres_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `23_35_Observed_or_Ve` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `24_36_Predominant_he` <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `25_37_Premises_type_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "r…
## $ `26_38_If_other_pleas` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `27_39_Type_of_associ` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `28_310_Car_parking_S` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `29_311_Goods_access_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `30_312_Are_these_pre` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `31_313_If_premises_a` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `32_314_When_did_the_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `33_315_Is_the_premis` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `34_316_If_rentedleas` <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `35_317_Will_the_leas` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `37_41_Is_the_localit` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `38_42_If_so_why_sele` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `39_43_If_locality_is` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `40_44_What_is_your_v` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `41_45_What_are_the_t` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `42_46_Where_are_the_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `43_47_Where_are_the_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `44_48_Is_the_organis` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `45_49_Does_the_organ` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `46_410_If_yes_where_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `47_411_If_yes_when` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `48_412_If_yes_why` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `49_413_Are_the_organ` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `50_414_If_yes_please` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `51_415_Are_you_aware` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `52_416_If_yes_how_ha` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `53_417_If_other_plea` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `54_418_What_is_your_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `56_51_Contact_willin` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `57_52_Name_of_contac` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `58_53_Contact_teleph` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `59_54_Contact_email_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `60_55_Organisation_t` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "0…
## $ `61_56_Organisation_w` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "v…
## $ `62_57_Organisation_e` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `63_58_Street_name_eg` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "S…
## $ `64_59_Street_number_` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `65_510_Postcode_Incl` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "S…
## $ `66_511_Unit_number_i` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "1…
## $ `68_61_Additional_not` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "A…
## $ `69_62_Internal_photo` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `71_71_Would_the_acti` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "n…
## $ lat_72_72_Location <dbl> 51.49604, NA, NA, NA, NA, NA, NA, NA, NA, …
## $ long_72_72_Location <dbl> -0.068400, NA, NA, NA, NA, NA, NA, NA, NA,…
## $ accuracy_72_72_Location <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 4,…
## $ `73_73_External_photo` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "h…
## $ `74_74_SIC_Code` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `76_76_Notes_on_any_o` <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ sD_RS_field_1 <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ sD_RS_6_12_Description_of_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "2…
## $ Polygon <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "Y…
## $ mb_comment <chr> "Industrial use in arches and yard. To che…
## $ comment_1 <chr> "on site survey", NA, NA, NA, NA, NA, NA, …
## $ comment_2 <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ comment_3 <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ pX <dbl> 534184.2, NA, NA, NA, NA, NA, NA, NA, NA, …
## $ pY <chr> "179224", NA, NA, NA, NA, NA, NA, NA, NA, …
## $ name <chr> "Max", "Max", "Max", "Max", "Max", "Max", …
## $ query_resolved <chr> "yes", "yes", "yes", "yes", "yes", "yes", …
## $ action_spatial <chr> "FUC polygon created", "FUC polygon create…
## $ action_spreadsheet <chr> "FUC added to record", "FUC added to recor…
## $ parcels_actions <chr> "None", "None", "None", "None", NA, NA, NA…
## $ action_other <chr> "Desktop survey undertaken", "Desktop surv…
## $ resolution_details <chr> "desktop survey established arches used fo…
options(scipen = 999)
glimpse(oct18)
## Rows: 2,515
## Columns: 101
## $ field_1.x <dbl> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12…
## $ ec5_uuid <chr> "09e71ebd-b430-421a-9866-21ebdbcc7462…
## $ created_at <dttm> 2019-10-13 23:11:31, 2019-10-03 16:3…
## $ title <chr> "Neil C 73 7300002", "Neil 52 6240006…
## $ X1_Surveyor_Nickname <chr> "Neil C", "Neil", "Neil", "Neil", "Ne…
## $ X2_Map_sheet_number <dbl> 73, 52, 52, 52, 52, 52, 52, 52, 52, 5…
## $ X3_Functional_Unit_Co <dbl> 7300002, 62400060, 62400059, 62400058…
## $ X5_11_Name_of_organis <chr> "East Dulwich Car Wash", "Alex Bartsc…
## $ X6_12_Description_of_ <chr> "Car washing", "Photographer", "Scree…
## $ X7_13_When_was_the_or <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X8_14_Do_you_regard_t <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X9_15_If_no_what_type <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X10_16_If_other_pleas <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X12_21_Total_number_o <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X13_22_Observed_or_Ve <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X14_23_How_many_FTEs_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X15_24_Observed_or_Ve <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X16_25_Is_the_organis <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X17_26_How_many_peopl <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X19_31_Floor_levels_t <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X20_32_How_many_store <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X21_33_Unit_size_Inse <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X22_34_Square_metres_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X23_35_Observed_or_Ve <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X24_36_Predominant_he <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X25_37_Premises_type_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X26_38_If_other_pleas <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X27_39_Type_of_associ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X28_310_Car_parking_S <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X29_311_Goods_access_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X30_312_Are_these_pre <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X31_313_If_premises_a <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X32_314_When_did_the_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X33_315_Is_the_premis <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X34_316_If_rentedleas <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X35_317_Will_the_leas <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X37_41_Is_the_localit <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X38_42_If_so_why_sele <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X39_43_If_locality_is <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X40_44_What_is_your_v <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X41_45_What_are_the_t <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X42_46_Where_are_the_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X43_47_Where_are_the_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X44_48_Is_the_organis <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X45_49_Does_the_organ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X46_410_If_yes_where_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X47_411_If_yes_when <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X48_412_If_yes_why <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X49_413_Are_the_organ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X50_414_If_yes_please <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X51_415_Are_you_aware <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X52_416_If_yes_how_ha <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X53_417_If_other_plea <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X54_418_What_is_your_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X56_51_Contact_willin <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X57_52_Name_of_contac <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X58_53_Contact_teleph <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X59_54_Contact_email_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X60_55_Organisation_t <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X61_56_Organisation_w <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X62_57_Organisation_e <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X63_58_Street_name_eg <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X64_59_Street_number_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X65_510_Postcode_Incl <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X66_511_Unit_number_i <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X68_61_Additional_not <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X69_62_Internal_photo <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X71_71_Would_the_acti <chr> "no", "no", "no", NA, NA, "no", "no",…
## $ lat_72_72_Location <dbl> 51.4577, NA, NA, NA, NA, NA, NA, NA, …
## $ long_72_72_Location <dbl> -0.075864, NA, NA, NA, NA, NA, NA, NA…
## $ accuracy_72_72_Location <dbl> 4, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ X73_73_External_photo <chr> "https://five.epicollect.net/api/medi…
## $ X74_74_SIC_Code <chr> "81299", NA, NA, NA, NA, NA, NA, NA, …
## $ X75_75_Site_ID <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X76_76_Notes_on_any_o <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ sD_RS_field_1 <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA…
## $ sD_RS_6_12_Description_of_...10 <chr> "Car washing", "Artist", "Artist", "A…
## $ Polygon <chr> "Yes", "Yes", "Yes", "Yes", "Yes", "Y…
## $ b_sheet <int> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ FUC <int> 7300002, 62400060, 62400059, 62400058…
## $ FUC_s <chr> "7300002", "62400060", "62400059", "6…
## $ field_1.y <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ query_code <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ fuc_2 <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ lat <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ long <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ sheet_no <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ sheet_no_2 <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ mb_note_no <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ mb_comment <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ comment_1 <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ comment_2 <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ comment_3 <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ description_M <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ description_updated <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ category <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ Map.Sheet.Number <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ Latitude_mi <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ Longitude_mi <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ Note_mi <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ geom <MULTIPOLYGON [m]> MULTIPOLYGON (((533784.5…
glimpse(pol)
## Rows: 310
## Columns: 2
## $ fid <chr> "15700001", "90200015", "90200001", "90200014", "62400064", …
## $ geometry <POLYGON [m]> POLYGON ((531583.3 179339.5..., POLYGON ((532081.4 1…
tmap_mode("view")
## tmap mode set to interactive viewing
qtm(pol, fill = "tomato")
glimpse(okr)
## Rows: 943
## Columns: 47
## $ Source...1 <chr> "2019", "2019"…
## $ `Business count` <dbl> 1, 1, 1, 1, 1,…
## $ `Business within MOB` <chr> "I", "I", NA, …
## $ `Multiple buildings` <chr> NA, NA, NA, NA…
## $ `Multi-occupier building` <chr> NA, NA, NA, NA…
## $ Source...6 <chr> NA, NA, "152",…
## $ codex <chr> "MOB", "MOB", …
## $ Join <dbl> NA, NA, 713, 0…
## $ Xcoord <chr> "MOB", "MOB", …
## $ Ycoord <chr> "MOB", "MOB", …
## $ AAP <chr> "Y", "Y", "Y",…
## $ `Site allocation` <chr> "OKR18", "OKR1…
## $ `Sub-area` <chr> "4", "4", "3",…
## $ `Business name` <chr> "1666 Fire", "…
## $ `Street no` <chr> NA, NA, "52-56…
## $ Unit <chr> NA, NA, NA, NA…
## $ Floor <chr> NA, NA, "0", "…
## $ Street <chr> "Daisy Busines…
## $ `2015-2019` <chr> "New", "Remain…
## $ Notes_on_C <chr> NA, NA, NA, NA…
## $ `Business activity` <chr> "Technical ser…
## $ `SIC CODE` <chr> "749", "181", …
## $ Sector <chr> "M Services: p…
## $ `Building use category` <chr> NA, NA, "Emplo…
## $ `Building type` <chr> "3_Pre-1945 fa…
## $ `Actual number of employee` <dbl> NA, NA, 9, 2, …
## $ `Estimated number of employee` <dbl> 4, 5, 0, 0, 0,…
## $ `TOTAL NUMBER OF EMPLOYEE` <dbl> 4, 5, 9, 2, 31…
## $ `employees for density` <dbl> NA, NA, 9, 2, …
## $ `GF multiplier` <chr> NA, NA, "1", "…
## $ `UF multiplier` <chr> NA, NA, "0.3",…
## $ `B multiplier` <chr> NA, NA, "0", "…
## $ Long_surve <chr> NA, NA, "N", "…
## $ `GF Floorspace area` <chr> NA, NA, "302.5…
## $ `UF Floorspace` <chr> NA, NA, "90.75…
## $ `Total floorspace` <chr> NA, NA, "393.2…
## $ `Total floorspace post VOA+15% analysis` <chr> NA, NA, "415.0…
## $ density <dbl> NA, NA, 43.694…
## $ `2.07 What % of employees of employees live locally? ` <chr> NA, NA, NA, NA…
## $ ...40 <dbl> NA, NA, NA, NA…
## $ ...41 <chr> NA, NA, NA, NA…
## $ ...42 <chr> NA, NA, NA, NA…
## $ ...43 <chr> NA, NA, NA, NA…
## $ ...44 <dbl> NA, NA, NA, NA…
## $ ...45 <dbl> NA, NA, NA, NA…
## $ ...46 <dbl> NA, NA, NA, NA…
## $ ...47 <dbl> NA, NA, NA, NA…
Identify what sD_RS_field_1 is - delete if not required for anything
Count NA in sD_RS_field_1
feb2021 %>%
filter(is.na(sD_RS_field_1)) %>%
nrow()
## [1] 2447
2447 out of 2548 are NA
feb2021 %>%
distinct(sD_RS_field_1)
Combine Comments 1, 2 and 3 into one column with comments separated by semicolons
feb2021e <- feb2021 %>%
mutate(comments = paste(comment_1, comment_2, comment_3, sep = "; "))
Note that under ‘action spatial’ is a category ‘FUC polygon needs deleting’ - delete these polygons and then delete these records Data frame with “FUC polygon needs deleting”
df_pnd <- feb2021e %>%
filter(action_spatial == "FUC polygon needs deleting") %>%
select("3_Functional_Unit_Co")
df_pnd
Remove values with “FUC polygon needs deleting”
feb2021e <- feb2021e %>%
filter(is.na(action_spatial) | action_spatial != "FUC polygon needs deleting")
Remove values with “FUC polygon needs deleting” from oct18
oct18 <- oct18 %>%
filter(!X3_Functional_Unit_Co %in% df_pnd$`3_Functional_Unit_Co`)
I assume we can delete those which do not have an FUC
Remove values where 3_Functional_Unit_Co == 0
feb2021e %>%
filter(is.na(`3_Functional_Unit_Co`)) %>%
nrow()
## [1] 38
feb2021e <- feb2021e %>%
filter(!is.na(`3_Functional_Unit_Co`))
Select unique 3_Functional_Unit_Co
feb2021e1 <- feb2021e %>%
distinct(`3_Functional_Unit_Co`, .keep_all = TRUE)
feb2021e1 has 2486 obs with 3_Functional_Unit_Co unique values
Join oct18 with 200601 New Polygons final upload (pol)
pol is more accurate than oct18 therefore if FUC are repeated pol features are kept
pol_fid <- pol %>%
pull(fid)
# reduce oct variable to fid and geometry
pol18 <- oct18 %>%
select(X3_Functional_Unit_Co) %>%
rename(fid = X3_Functional_Unit_Co,
geometry = geom) %>%
st_set_crs(value = 27700) %>%
filter(!fid %in% pol_fid)
## Warning: st_crs<- : replacing crs does not reproject data; use st_transform for
## that
head(pol18)
pol18
Simple feature collection with 2429 features and 1 field (with 452 geometries empty)
pol181 <- pol18[!st_is_empty(pol18),,drop=FALSE]
Remove duplicated fid and geometry
pol181 <- pol181 %>%
unique.data.frame()
pol %>%
filter(fid == 90220001)
## Warning in `[<-.data.frame`(`*tmp*`, is_list, value = list(`2` = "<s_GEOMET>")):
## replacement element 1 has 1 row to replace 0 rows
# Remove duplicated fid and geometry in pol
pol1 <- pol %>%
unique.data.frame()
pol_all <- rbind(pol181, pol1)
qtm(pol_all, fill = "tomato")
Merge pol_all (oct18 and New Polygons) with feb2021 table by FUC
| object | n |
|---|---|
| pol_all | 2273 |
| feb2021e | 2486 |
mall <- pol_all %>%
mutate(fid = as.numeric(fid)) %>%
left_join(feb2021e1, by = c(fid = "3_Functional_Unit_Co"), keep = TRUE) %>%
st_make_valid() %>%
st_collection_extract() # convert from type GEOMETRY to type MULTIPOLYGON
qtm(mall, fill = "tomato")